Raw Request:
POST /listings/_search?pretty=true&error_trace=true&typed_keys=true
{"from":0,"query":{"bool":{"filter":[{"terms":{"systemid":[406,407]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_search":[0,1]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_postalcode":{"operator":"and","query":"29118"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"SC","type":"cross_fields"}}]}},"size":25,"sort":[{"date_list":{"order":"desc"}}],"_source":{"includes":["systemid","detailtablename","id_listinguid","id_listingid","id_primarylistingoffice","id_primarylistingofficename","id_primarylistingagent","status_display","location_streetaddress","location_city","location_state","location_postalcode","bedrooms","bathrooms_total","price_list","price_closed","primaryimage","squarefootage","geo_coordinates","type_search","type_transactiontype","type_propertytype","type_status","obj_openhouses","date_list","remarks","flag_*"]}}
Raw Response:
{
"took" : 7,
"timed_out" : false,
"_shards" : {
"total" : 3,
"successful" : 3,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 40,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-584155",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-584155",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "5490",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1486 Sifly Road",
"flag_internetadvertise" : true,
"price_list" : 199000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.855713,
"lat" : 33.537476
},
"id_primarylistingofficename" : "Real Estate Associates LLC",
"type_propertytype" : 0,
"date_list" : "2024-04-30T00:00:00",
"location_postalcode" : "29118-1336",
"bedrooms" : 3,
"id_primarylistingoffice" : "818",
"squarefootage" : 1566,
"id_listingid" : "584155",
"type_transactiontype" : 0
},
"sort" : [
1714435200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-210898",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-210898",
"type_search" : 1,
"bathrooms_total" : 2,
"id_primarylistingagent" : "110_262",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "995 Hampton Drive",
"flag_internetadvertise" : true,
"price_list" : 163000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.909539,
"lat" : 33.522891
},
"id_primarylistingofficename" : "Aiken Premier Realty",
"type_propertytype" : 0,
"date_list" : "2024-03-22T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "110",
"squarefootage" : 1517,
"id_listingid" : "210898",
"type_transactiontype" : 0
},
"sort" : [
1711065600000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-210735",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-210735",
"type_search" : 1,
"bathrooms_total" : 2,
"id_primarylistingagent" : "110_262",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1719 Elizabeth Street",
"flag_internetadvertise" : true,
"price_list" : 175000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.867926,
"lat" : 33.522339
},
"id_primarylistingofficename" : "Aiken Premier Realty",
"type_propertytype" : 0,
"date_list" : "2024-03-12T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "110",
"squarefootage" : 1474,
"id_listingid" : "210735",
"type_transactiontype" : 0
},
"sort" : [
1710201600000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-210475",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-210475",
"id_primarylistingofficename" : "Nexthome Realty Consultants",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "120_352",
"date_list" : "2024-02-25T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "109 Lombardi Court",
"location_postalcode" : "29118",
"bedrooms" : 3,
"flag_internetadvertise" : true,
"price_list" : 239000.0,
"id_primarylistingoffice" : "120",
"squarefootage" : 1649,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.94385,
"lat" : 33.555549
},
"id_listingid" : "210475",
"type_transactiontype" : 0
},
"sort" : [
1708819200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-579378",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-579378",
"id_primarylistingofficename" : "Keller Williams Realty",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "12321",
"date_list" : "2024-02-19T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "482 Rogers Drive",
"location_postalcode" : "29118",
"bedrooms" : 3,
"flag_internetadvertise" : true,
"price_list" : 240000.0,
"id_primarylistingoffice" : "669",
"squarefootage" : 1702,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.809066,
"lat" : 33.527932
},
"id_listingid" : "579378",
"type_transactiontype" : 0
},
"sort" : [
1708300800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-210390",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-210390",
"type_search" : 1,
"bathrooms_total" : 3,
"id_primarylistingagent" : "447_404",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "482 Rogers Drive",
"flag_internetadvertise" : true,
"price_list" : 240000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.809066,
"lat" : 33.527932
},
"id_primarylistingofficename" : "Keller Williams Realty",
"type_propertytype" : 0,
"date_list" : "2024-02-19T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "447",
"squarefootage" : 1702,
"id_listingid" : "210390",
"type_transactiontype" : 0
},
"sort" : [
1708300800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-579023",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-579023",
"type_search" : 0,
"bathrooms_total" : 0,
"id_primarylistingagent" : "12719",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "0 Red Bank Road",
"flag_internetadvertise" : true,
"price_list" : 200000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.9086617462158,
"lat" : 33.5437597809016
},
"id_primarylistingofficename" : "BHHS Midlands Real Estate",
"type_propertytype" : 50,
"date_list" : "2024-02-13T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 0,
"id_primarylistingoffice" : "682",
"squarefootage" : 1,
"id_listingid" : "579023",
"type_transactiontype" : 0
},
"sort" : [
1707782400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-578914",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-578914",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "14217",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "127 Waycross Street",
"flag_internetadvertise" : true,
"price_list" : 123900.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.797004,
"lat" : 33.549976
},
"id_primarylistingofficename" : "JPAR Magnolia Group",
"type_propertytype" : 0,
"date_list" : "2024-02-09T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "1269",
"squarefootage" : 1025,
"id_listingid" : "578914",
"type_transactiontype" : 0
},
"sort" : [
1707436800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-210167",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-210167",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "120_352",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "33 Keener Court",
"flag_internetadvertise" : true,
"price_list" : 220900.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.944104,
"lat" : 33.553245
},
"id_primarylistingofficename" : "Nexthome Realty Consultants",
"type_propertytype" : 0,
"date_list" : "2024-02-05T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "120",
"squarefootage" : 1380,
"id_listingid" : "210167",
"type_transactiontype" : 0
},
"sort" : [
1707091200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-576985",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-576985",
"id_primarylistingofficename" : "EXIT Real Est Consultants",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "8131",
"date_list" : "2024-01-11T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "294 Plantation Drive 34",
"location_postalcode" : "29118",
"bedrooms" : 4,
"flag_internetadvertise" : true,
"price_list" : 245000.0,
"id_primarylistingoffice" : "731",
"squarefootage" : 1762,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.883093,
"lat" : 33.514593
},
"id_listingid" : "576985",
"type_transactiontype" : 0
},
"sort" : [
1704931200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-576361",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-576361",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "2484",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "395 PARTRIDGE Road",
"flag_internetadvertise" : true,
"price_list" : 210000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.907045,
"lat" : 33.534982
},
"id_primarylistingofficename" : "Morris Morgan Realty",
"type_propertytype" : 0,
"date_list" : "2023-12-29T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 4,
"id_primarylistingoffice" : "262",
"squarefootage" : 2209,
"id_listingid" : "576361",
"type_transactiontype" : 0
},
"sort" : [
1703808000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-575670",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-575670",
"id_primarylistingofficename" : "Keller Williams Preferred",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "12194",
"date_list" : "2023-12-14T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "924 Graham Street",
"location_postalcode" : "29118",
"bedrooms" : 4,
"flag_internetadvertise" : true,
"price_list" : 75000.0,
"id_primarylistingoffice" : "970",
"squarefootage" : 1144,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.849796,
"lat" : 33.519447
},
"id_listingid" : "575670",
"type_transactiontype" : 0
},
"sort" : [
1702512000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-575561",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-575561",
"id_primarylistingofficename" : "Better Homes and Gardens Real Est Medley",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 1,
"id_primarylistingagent" : "9258",
"date_list" : "2023-12-12T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "108 Eastwood Circle",
"location_postalcode" : "29118",
"bedrooms" : 3,
"flag_internetadvertise" : true,
"price_list" : 130000.0,
"id_primarylistingoffice" : "1065",
"squarefootage" : 1066,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.799415,
"lat" : 33.548136
},
"id_listingid" : "575561",
"type_transactiontype" : 0
},
"sort" : [
1702339200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-574947",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-574947",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "16847",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "678 Hampton Drive",
"flag_internetadvertise" : true,
"price_list" : 175000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.906601,
"lat" : 33.526611
},
"id_primarylistingofficename" : "Keller Williams Realty",
"type_propertytype" : 0,
"date_list" : "2023-12-01T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "669",
"squarefootage" : 1694,
"id_listingid" : "574947",
"type_transactiontype" : 0
},
"sort" : [
1701388800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-573991",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-573991",
"id_primarylistingofficename" : "JPAR Magnolia Group",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "14217",
"date_list" : "2023-11-10T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "109 Lombardi Court",
"location_postalcode" : "29118",
"bedrooms" : 3,
"flag_internetadvertise" : true,
"price_list" : 244900.0,
"id_primarylistingoffice" : "1269",
"squarefootage" : 1649,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.94385,
"lat" : 33.555549
},
"id_listingid" : "573991",
"type_transactiontype" : 0
},
"sort" : [
1699574400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-573641",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-573641",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "14217",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "696 Alexander Drive",
"flag_internetadvertise" : true,
"price_list" : 255000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.9073,
"lat" : 33.527772
},
"id_primarylistingofficename" : "JPAR Magnolia Group",
"type_propertytype" : 0,
"date_list" : "2023-11-07T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "1269",
"squarefootage" : 2028,
"id_listingid" : "573641",
"type_transactiontype" : 0
},
"sort" : [
1699315200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-573587",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-573587",
"id_primarylistingofficename" : "Keller Williams Realty",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "16847",
"date_list" : "2023-11-06T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "0 Providence Road",
"location_postalcode" : "29118",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 130500.0,
"id_primarylistingoffice" : "669",
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.9643640053711,
"lat" : 33.6123025831496
},
"id_listingid" : "573587",
"type_transactiontype" : 0
},
"sort" : [
1699228800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-573023",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-573023",
"id_primarylistingofficename" : "eXp Realty LLC",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 0,
"id_primarylistingagent" : "15245",
"date_list" : "2023-10-27T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1328 Lands End Street",
"location_postalcode" : "29118",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 170000.0,
"id_primarylistingoffice" : "1344",
"squarefootage" : 1890,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.855783,
"lat" : 33.527432
},
"id_listingid" : "573023",
"type_transactiontype" : 0
},
"sort" : [
1698364800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-573677",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-573677",
"id_primarylistingofficename" : "JPAR Magnolia Group",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "16825",
"date_list" : "2023-10-05T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1446 Rhoad Street",
"location_postalcode" : "29118",
"bedrooms" : 3,
"flag_internetadvertise" : true,
"price_list" : 207000.0,
"id_primarylistingoffice" : "1316",
"squarefootage" : 2008,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.85999,
"lat" : 33.521774
},
"id_listingid" : "573677",
"type_transactiontype" : 0
},
"sort" : [
1696464000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-208537",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-208537",
"type_search" : 1,
"bathrooms_total" : 3,
"id_primarylistingagent" : "472_525",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "319 Partridge Road",
"flag_internetadvertise" : true,
"price_list" : 275000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.906414,
"lat" : 33.535877
},
"id_primarylistingofficename" : "Grei Realty, LLC",
"type_propertytype" : 0,
"date_list" : "2023-10-04T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "grealty",
"squarefootage" : 1986,
"id_listingid" : "208537",
"type_transactiontype" : 0
},
"sort" : [
1696377600000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-570580",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-570580",
"id_primarylistingofficename" : "Excel Real Estate LLC",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "17450",
"date_list" : "2023-09-18T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "681 New Hope Road",
"location_postalcode" : "29118",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 50000.0,
"id_primarylistingoffice" : "1173",
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.862881,
"lat" : 33.61098
},
"id_listingid" : "570580",
"type_transactiontype" : 0
},
"sort" : [
1694995200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-208170",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-208170",
"type_search" : 1,
"bathrooms_total" : 2,
"id_primarylistingagent" : "110_262",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "180 S Circle Drive NW",
"flag_internetadvertise" : true,
"price_list" : 140000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.882113,
"lat" : 33.51732
},
"id_primarylistingofficename" : "Aiken Premier Realty",
"type_propertytype" : 0,
"date_list" : "2023-09-13T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "110",
"squarefootage" : 1421,
"id_listingid" : "208170",
"type_transactiontype" : 0
},
"sort" : [
1694563200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-569446",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-569446",
"type_search" : 0,
"bathrooms_total" : 1,
"id_primarylistingagent" : "15999",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "105 Jones Drive",
"flag_internetadvertise" : true,
"price_list" : 130000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.903686,
"lat" : 33.553731
},
"id_primarylistingofficename" : "Keller Williams Palmetto",
"type_propertytype" : 0,
"date_list" : "2023-08-30T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 3,
"id_primarylistingoffice" : "1274",
"squarefootage" : 1190,
"id_listingid" : "569446",
"type_transactiontype" : 0
},
"sort" : [
1693353600000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-207915",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-207915",
"id_primarylistingofficename" : "The Palmetto Real Estate Group",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "473_2",
"date_list" : "2023-08-23T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "3583 Kennerly Road",
"location_postalcode" : "29118",
"bedrooms" : 5,
"flag_internetadvertise" : true,
"price_list" : 179000.0,
"id_primarylistingoffice" : "473",
"squarefootage" : 2313,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.902939,
"lat" : 33.555947
},
"id_listingid" : "207915",
"type_transactiontype" : 0
},
"sort" : [
1692748800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-567224",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-567224",
"type_search" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "15482",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "2967 Lakeside Street",
"flag_internetadvertise" : true,
"price_list" : 247000.0,
"location_city" : "Orangeburg",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.873107,
"lat" : 33.532118
},
"id_primarylistingofficename" : "Keller Williams Palmetto",
"type_propertytype" : 19,
"date_list" : "2023-07-26T00:00:00",
"location_postalcode" : "29118",
"bedrooms" : 4,
"id_primarylistingoffice" : "1274",
"squarefootage" : 2350,
"id_listingid" : "567224",
"type_transactiontype" : 0
},
"sort" : [
1690329600000
]
}
]
}
}